package com.zzyl.nursing.service.impl;

import java.time.LocalDateTime;
import java.util.*;

import cn.hutool.core.collection.ListUtil;
import cn.hutool.core.date.LocalDateTimeUtil;
import com.aliyun.iot20180120.models.QueryDevicePropertyStatusRequest;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.zzyl.common.core.domain.AjaxResult;
import com.zzyl.common.utils.UserThreadLocal;
import com.zzyl.framework.web.service.TokenService;
import com.zzyl.nursing.domain.FamilyMemberElder;
import com.zzyl.nursing.dto.UserLoginRequestDto;
import com.zzyl.nursing.mapper.*;
import com.zzyl.nursing.service.IDeviceService;
import com.zzyl.nursing.service.WechatService;
import com.zzyl.nursing.vo.DeviceDataGraphVo;
import com.zzyl.nursing.vo.FamilyMemberElderListVo;
import com.zzyl.nursing.vo.FamilyMemberElderVo;
import com.zzyl.nursing.vo.LoginVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.zzyl.nursing.domain.FamilyMember;
import com.zzyl.nursing.service.IFamilyMemberService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

/**
 * 老人家属Service业务层处理
 * 
 * @author alexis
 * @date 2024-11-10
 */
@Service
public class FamilyMemberServiceImpl extends ServiceImpl<FamilyMemberMapper, FamilyMember> implements IFamilyMemberService
{
    @Autowired
    private FamilyMemberMapper familyMemberMapper;

    @Autowired
    private FamilyMemberElderMapper familyMemberElderMapper;


    @Autowired
    private WechatService wechatService;

    @Autowired
    private TokenService tokenService;

    @Autowired
    private RoomMapper roomMapper;

    @Autowired
    private DeviceMapper deviceMapper;

    static List<String> DEFAULT_NICKNAME_PREFIX = ListUtil.of(
            "生活更美好",
            "大桔大利",
            "日富一日",
            "好柿开花",
            "柿柿如意",
            "一椰暴富",
            "大柚所为",
            "杨梅吐气",
            "天生荔枝"
    );
    @Autowired
    private ElderMapper elderMapper;
    @Autowired
    private BedMapper bedMapper;

    /**
     * 查询老人家属
     * 
     * @param id 老人家属主键
     * @return 老人家属
     */
    @Override
    public FamilyMember selectFamilyMemberById(Long id)
    {
        return getById(id);
    }

    /**
     * 查询老人家属列表
     * 
     * @param familyMember 老人家属
     * @return 老人家属
     */
    @Override
    public List<FamilyMember> selectFamilyMemberList(FamilyMember familyMember)
    {
        return familyMemberMapper.selectFamilyMemberList(familyMember);
    }

    /**
     * 新增老人家属
     * 
     * @param familyMember 老人家属
     * @return 结果
     */
    @Override
    public int insertFamilyMember(FamilyMember familyMember)
    {
        return save(familyMember) ? 1 : 0;
    }

    /**
     * 修改老人家属
     * 
     * @param familyMember 老人家属
     * @return 结果
     */
    @Override
    public int updateFamilyMember(FamilyMember familyMember)
    {
        return updateById(familyMember) ? 1 : 0;
    }

    /**
     * 批量删除老人家属
     * 
     * @param ids 需要删除的老人家属主键
     * @return 结果
     */
    @Override
    public int deleteFamilyMemberByIds(Long[] ids)
    {
        return removeByIds(Arrays.asList(ids)) ? 1 : 0;
    }

    /**
     * 删除老人家属信息
     * 
     * @param id 老人家属主键
     * @return 结果
     */
    @Override
    public int deleteFamilyMemberById(Long id)
    {
        return removeById(id) ? 1 : 0;
    }

    /**
     * 新增或更新小程序端用户
     *
     */
    @Override
    public LoginVo saveFamilyMember(UserLoginRequestDto userLoginRequestDto) {
        // 1.获取openid
        String openId = wechatService.getOpenId(userLoginRequestDto.getCode());

        // 2.根据openid查询family_member表获取家属信息
        FamilyMember familyMember = familyMemberMapper.selectOne(Wrappers.<FamilyMember>lambdaQuery()
                .eq(FamilyMember::getOpenId, openId));

        // 3.判断家属信息是否为空，如果为空，创建家属对象，并赋值openid
        if (ObjectUtils.isEmpty(familyMember)) {
            familyMember = new FamilyMember();
            familyMember.setOpenId(openId);
        }

        // 4.根据phoneCode获取手机号
        String phoneNumber = wechatService.getPhoneNumber(userLoginRequestDto.getPhoneCode());
        familyMember.setPhone(phoneNumber);

        // 5.新增或更新家属信息，如果第一次登录，需要生成一个随机的昵称
        insertOrUpdateFamilyMember(familyMember, phoneNumber);

        // 6.把用户id和昵称封装到jwt中返回
        Map<String, Object> claims = new HashMap<>();
        claims.put("userId", familyMember.getId());
        claims.put("nickName", familyMember.getName());

        String token = tokenService.createToken(claims);

        LoginVo loginVo = new LoginVo();
        loginVo.setToken(token);
        loginVo.setNickName(familyMember.getName());

        return loginVo;
    }

    /**
     * 新增或更新家属信息
     * @param familyMember  家属信息
     * @param phoneNumber   最新的手机号
     */
    private void insertOrUpdateFamilyMember(FamilyMember familyMember, String phoneNumber) {
        // 新增或更新老人家属
        if (ObjectUtils.isEmpty(familyMember.getId())) {
            // 判断是否为第一次登录，如果是，则生成一个随机昵称
            // 从集合中随机一个名字，再拼上手机号后四位
            int index = (int) (Math.random() * DEFAULT_NICKNAME_PREFIX.size());
            familyMember.setName(DEFAULT_NICKNAME_PREFIX.get(index) + phoneNumber.substring(phoneNumber.length() - 4));

            // id为空，新增
            familyMemberMapper.insert(familyMember);
        } else {
            // id不为空，修改
            familyMemberMapper.updateById(familyMember);
        }

    }


    /**
     * 绑定家人
     *
     * @param familyMemberElder
     */
    @Override
    public void addMemberElder(FamilyMemberElder familyMemberElder) {
        Long userId = UserThreadLocal.getUserId();

        Long elderId = elderMapper.getIdByIdCardNo(familyMemberElder.getIdCard());
        if (elderId == null) {
            throw new RuntimeException("该老人不存在");
        }
        FamilyMemberElder familyMemberElder1 = new FamilyMemberElder();
        familyMemberElder1.setFamilyMemberId(userId);
        familyMemberElder1.setElderId(elderId);
        familyMemberElder1.setRemark(familyMemberElder.getRemark());
        familyMemberElder1.setCreateTime(LocalDateTime.now());
        familyMemberElder1.setUpdateTime(LocalDateTime.now());
        familyMemberElder1.setCreateBy(userId.toString());
        familyMemberElder1.setUpdateBy(userId.toString());


        familyMemberElderMapper.insert(familyMemberElder1);
    }

    /**
     * 查询我的家人列表
     *
     * @return
     */
    @Override
    public List<FamilyMemberElderVo> selectMyElders() {

        //从family_member_elder表中根据用户id查询出对应的老人信息
        List<FamilyMemberElderVo> result = familyMemberElderMapper.selectByFamilyMemberId(UserThreadLocal.getUserId());

        result.forEach(item -> item.setElderName(elderMapper.selectById(item.getElderId()).getName()));
        result.forEach(item -> item.setFamilyMemberId(UserThreadLocal.getUserId()));

        return result;
    }

    /**
     * 分页查询我的家人列表
     *
     * @param pageNum
     * @param pageSize
     * @return
     */
    @Override
    public List<FamilyMemberElderListVo> getFamilyMemberElderList(Integer pageNum, Integer pageSize) {

        // 开始分页
        PageHelper.startPage(pageNum, pageSize);

        //定义一个方法拿到完整的FamilyMemberElderListVo
        List<FamilyMemberElderListVo> result = familyMemberElderMapper.selectFamilyMemberElderList();

        return result;
    }

    @Autowired
    private IDeviceService deviceService;
    /**
     * 查询健康数据
     *
     * @param request
     * @return
     */
    @Override
    public AjaxResult queryDevicePropertyStatus(QueryDevicePropertyStatusRequest request) {
        AjaxResult ajaxResult =deviceService.queryDevicePropertyStatus(request);
        return ajaxResult;
    }

    /**
     * 按天查询指标数据
     *
     * @param iotId      设备id
     * @param functionId 物模型id
     * @param startTime  查询开始时间
     * @param endTime    查询结束时间
     * @return 每小时数据
     */
    @Override
    public List<DeviceDataGraphVo> queryDeviceDataListByDay(String iotId, String functionId, Long startTime, Long endTime) {
        // 获取一天内每个小时数据的临时结果
        List<DeviceDataGraphVo> dayInstances = DeviceDataGraphVo.getDayInstances(LocalDateTimeUtil.of(startTime));

        // 从数据库中查询一天内每个小时实际数据结果
        List<DeviceDataGraphVo> result = familyMemberMapper.queryDeviceDataListByDay(iotId, functionId, LocalDateTimeUtil.of(startTime), LocalDateTimeUtil.of(endTime));

        // 遍历临时结果，将数据库中查询到的结果拼接进去
        for (DeviceDataGraphVo dayInstance : dayInstances) {
            result.forEach(data -> {
                if (dayInstance.getDateTime().equals(data.getDateTime())) {
                    dayInstance.setDataValue(data.getDataValue());
                }
            });
        }

        return dayInstances;
    }

    /**
     * 按周查询指标数据
     *
     * @param iotId      设备id
     * @param functionId 物模型id
     * @param startTime  查询开始时间
     * @param endTime    查询结束时间
     * @return 每小时数据
     */
    @Override
    public List<DeviceDataGraphVo> queryDeviceDataListByWeek(String iotId, String functionId, Long startTime, Long endTime) {
        // 获取一天内每个小时数据的临时结果
        List<DeviceDataGraphVo> weekInstances = DeviceDataGraphVo.getWeekInstances(LocalDateTimeUtil.of(startTime));

        // 从数据库中查询一天内每个小时实际数据结果
        List<DeviceDataGraphVo> result = familyMemberMapper.queryDeviceDataListByWeek(iotId, functionId, LocalDateTimeUtil.of(startTime), LocalDateTimeUtil.of(endTime));

        // 遍历临时结果，将数据库中查询到的结果拼接进去
        for (DeviceDataGraphVo dayInstance : weekInstances) {
            result.forEach(data -> {
                if (dayInstance.getDateTime().equals(data.getDateTime())) {
                    dayInstance.setDataValue(data.getDataValue());
                }
            });
        }

        return weekInstances;
    }

    //    private List<FamilyMemberElderListVo> selectFamilyMemberElderList() {
//        //先从family_member_elder表中拿到所有的值
//        List<FamilyMemberElder> familyMemberElders = familyMemberElderMapper.selectAll();
//
//        List<FamilyMemberElderListVo> result = new ArrayList<>();
//
//        for (FamilyMemberElder familyMemberElder : familyMemberElders) {
//            Long mid = familyMemberElder.getFamilyMemberId();
//            String mremark = familyMemberElder.getRemark();
//            Long elderId = familyMemberElder.getElderId();
//
//            //从elder表中根据FamilyMemberElder表的列表数据的其中一条中的elderId拿到对应的值
//            FamilyMemberElderListVo familyMemberElderListVo = elderMapper.selectFamilyMemberElderById(elderId);
//
//            familyMemberElderListVo.setMid(mid);
//            familyMemberElderListVo.setMremark(mremark);
//            familyMemberElderListVo.setElderId(elderId);
//
//            //根据老人表中老人的床位id拿到床位表中的roomId
//            String bedNumber = familyMemberElderListVo.getBedNumber();
//            Long roomId = bedMapper.selectRoomIdByBedNumber(bedNumber);
//            //用roomId在room表中拿到typeName
//            String typeName = roomMapper.selectById(roomId).getTypeName();
//            familyMemberElderListVo.setTypeName(typeName);
//
//            //用老人名字在device表中查设备信息
//
//            String remark = familyMemberElderListVo.getName();
//            String iotId = deviceMapper.selectIotByRemark(remark);
//            if (iotId != null) {
//                String deviceName = deviceMapper.selectOne(new LambdaQueryWrapper<Device>().eq(Device::getIotId, iotId)).getDeviceName();
//                String productKey = deviceMapper.selectOne(new LambdaQueryWrapper<Device>().eq(Device::getIotId, iotId)).getProductKey();
//                //如果有设备那么就保存到FamilyMemberElderListVo中
//                familyMemberElderListVo.setIotId(iotId);
//                familyMemberElderListVo.setDeviceName(deviceName);
//                familyMemberElderListVo.setProductKey(productKey);
//            }
//
//
//
//            result.add(familyMemberElderListVo);
//        }
//
//        return result;
//
//    }  ！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！
}
